USE EstudiosComerciales
go
IF OBJECT_ID('dbo.WASP_D0006_ACTUALIZA_FLAG_LHDCIDB02') IS NOT NULL
BEGIN
    DROP PROCEDURE dbo.WASP_D0006_ACTUALIZA_FLAG_LHDCIDB02
    IF OBJECT_ID('dbo.WASP_D0006_ACTUALIZA_FLAG_LHDCIDB02') IS NOT NULL
        PRINT '<<< FAILED DROPPING PROCEDURE dbo.WASP_D0005_ACTUALIZA_FLAG_LHDCIDB02 >>>'
    ELSE
        PRINT '<<< DROPPED PROCEDURE dbo.WASP_D0006_ACTUALIZA_FLAG_LHDCIDB02 >>>'
END
go
SET ANSI_NULLS ON
go
SET QUOTED_IDENTIFIER ON
go
CREATE PROCEDURE [dbo].[WASP_D0006_ACTUALIZA_FLAG_LHDCIDB02]
AS
 
BEGIN
UPDATE [SQL].[FLAG_PD] SET  FLAG = FLAG + 1 , CDATE = GETDATE()
END
go
SET ANSI_NULLS OFF
go
SET QUOTED_IDENTIFIER OFF
go
IF OBJECT_ID('dbo.WASP_D0006_ACTUALIZA_FLAG_LHDCIDB02') IS NOT NULL
    PRINT '<<< CREATED PROCEDURE dbo.WASP_D0006_ACTUALIZA_FLAG_LHDCIDB02 >>>'
ELSE
    PRINT '<<< FAILED CREATING PROCEDURE dbo.WASP_D0006_ACTUALIZA_FLAG_LHDCIDB02 >>>'
go
